Model Table BUSINESS OPP SNAPSHOT
This model dimension represents business opportunity snapshots and is based on the IFS Cloud fact FACT_BUSINESS_ACTIVITY. All models that refers to this dimension will have the attributes and hierarchies as described below.
Attributes
| Attribute |
Description (where applicable) |
| Description | The description of the business opportunity. |
| Opportunity Type | The opportunity type of the business opportunity. |
| Opportunity Type Description | The opportunity type of the business opportunity. |
| Reason Note | The reason note set when closing the business opportunity. |
| Snapshot Date | The date calculated by adding the time offset to the execution date of the snapshot creation job. |
| State | The status of the business opportunity. |
| State Description | The status of the business opportunity. |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| BUSINESS OPP SNAPSHOT | FACT_BUSINESS_OPP_SNAPSHOT_TM | FACT_BUSINESS_OPP_SNAPSHOT_BI | FACT_BUSINESS_OPP_SNAPSHOT | Data Mart |